/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : 127.0.0.1
 Source Database       : whoscored

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : utf-8

 Date: 03/04/2018 15:42:38 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `qt_team`
-- ----------------------------
DROP TABLE IF EXISTS `qt_team`;
CREATE TABLE `qt_team` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wid` int(11) DEFAULT NULL,
  `qid` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `wid` (`wid`)
) ENGINE=InnoDB AUTO_INCREMENT=1106 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qt_team`
-- ----------------------------
BEGIN;
INSERT INTO `qt_team` VALUES ('455', '448', '410', '哈马比'), ('456', '2517', '2156', '奥斯特桑斯'), ('457', '450', '1518', '赫根'), ('458', '452', '417', '埃尔夫斯堡'), ('459', '493', '408', '马尔默'), ('460', '435', '2165', '诺科平'), ('461', '488', '426', '卡尔马'), ('462', '2491', '2322', '佐高平斯'), ('463', '453', '400', '索尔纳'), ('464', '449', '406', '松兹瓦尔'), ('465', '459', '1519', '耶夫勒'), ('466', '428', '404', '赫尔辛堡'), ('467', '2067', '1527', '法尔肯堡'), ('468', '451', '413', '哥德堡'), ('469', '434', '419', '奥雷布洛'), ('470', '479', '421', '佐加顿斯'), ('471', '433', '424', '哈尔姆斯达斯'), ('472', '1556', '21197', 'AFC联'), ('473', '2509', '2782', '天狼星'), ('474', '1224', '453', '圣保罗'), ('475', '1239', '356', '弗拉门戈'), ('476', '1234', '465', '帕尔梅拉斯'), ('477', '1235', '343', '米内罗竞技'), ('478', '1232', '469', '弗鲁米嫩塞'), ('479', '8863', '13147', '积安维尔'), ('480', '1226', '456', '瓦斯科达伽马'), ('481', '1218', '360', '戈伊亚斯'), ('482', '1244', '364', '格雷米奥'), ('483', '1240', '381', '庞特普雷塔'), ('484', '1230', '354', '克鲁塞罗'), ('485', '1237', '349', '科林蒂安'), ('486', '4619', '4175', '奥瓦'), ('487', '1241', '337', '桑托斯'), ('488', '1243', '347', '巴拉纳竞技'), ('489', '1219', '369', '巴西国际'), ('490', '1231', '4176', '累西腓体育'), ('491', '1766', '355', '费古埃伦斯'), ('492', '8865', '7344', '沙佩科恩斯'), ('493', '1236', '350', '科里蒂巴'), ('494', '1227', '467', '博塔弗戈'), ('495', '1228', '13219', '米内罗美洲'), ('496', '1242', '2096', '圣十字'), ('497', '1238', '462', '维多利亚'), ('498', '6368', '5156', '戈亚尼亚竞技'), ('499', '1221', '1979', '巴伊亚'), ('500', '2066', '352', '克里丘马'), ('501', '37', '88', '拜仁慕尼黑'), ('502', '38', '160', '汉堡'), ('503', '44', '99', '多特蒙德'), ('504', '134', '128', '门兴格拉德巴赫'), ('505', '36', '165', '勒沃库森'), ('506', '1211', '1078', '霍芬海姆'), ('507', '33', '149', '沃尔夫斯堡'), ('508', '45', '423', '法兰克福'), ('509', '41', '155', '斯图加特'), ('510', '282', '490', '科隆'), ('511', '1730', '1135', '奥格斯堡'), ('512', '47', '139', '柏林赫塔'), ('513', '42', '132', '云达不莱梅'), ('514', '39', '151', '沙尔克04'), ('515', '219', '162', '美因茨'), ('516', '3429', '2786', '因戈尔施塔特'), ('517', '1147', '1080', '达姆斯塔特'), ('518', '110', '169', '汉诺威96'), ('519', '810', '1720', '柏德博恩'), ('520', '50', '172', '弗赖堡'), ('521', '7614', '13201', 'RB莱比锡'), ('522', '1138', '1116', '布伦斯维克'), ('523', '137', '136', '纽伦堡'), ('524', '35', '493', '杜伊斯堡'), ('525', '43', '175', '凯泽斯劳滕'), ('526', '109', '95', '波鸿'), ('527', '3882', '4449', '桑德豪森'), ('528', '796', '1087', '柏林联合'), ('529', '1150', '1344', '杜塞尔多夫'), ('530', '89', '458', '菲尔特'), ('531', '112', '487', '卡尔斯鲁厄'), ('532', '283', '1085', '圣保利'), ('533', '40', '90', '比勒菲尔德'), ('534', '4852', '8371', '海登海默'), ('535', '34', '403', '慕尼黑1860'), ('536', '4676', '6021', 'FSV法兰克福'), ('537', '5634', '6073', '维尔茨堡踢球者'), ('538', '813', '461', '奥厄'), ('539', '1731', '425', '德累斯顿'), ('540', '1147', '1080', '达姆斯塔特'), ('541', '1143', '1079', '雷根斯堡'), ('542', '1206', '1117', '基尔高士丁'), ('543', '165', '68', '伊普斯维奇'), ('544', '189', '365', '布伦特福德'), ('545', '157', '32', '伯明翰'), ('546', '94', '66', '雷丁'), ('547', '158', '21', '布莱克本'), ('548', '161', '52', '狼队'), ('549', '92', '22', '博尔顿'), ('550', '20', '47', '德比郡'), ('551', '174', '49', '诺丁汉森林'), ('552', '160', '23', '查尔顿'), ('553', '19', '56', '利兹联'), ('554', '181', '55', '普雷斯顿'), ('555', '210', '54', '罗瑟汉姆'), ('556', '28', '334', '米尔顿凯恩斯'), ('557', '25', '336', '谢周三'), ('558', '182', '379', '布里斯托城'), ('559', '194', '61', '维冈竞技'), ('560', '93', '377', '布莱克浦'), ('561', '192', '69', '米尔沃尔'), ('562', '142', '378', '巴恩斯利'), ('563', '1786', '1381', '伯顿'), ('564', '163', '51', '谢菲尔德联队'), ('565', '922', '1211', '耶奥维尔'), ('566', '910', '341', '唐卡斯特'), ('567', '446', '498', '布兰'), ('568', '1645', '2255', '萨普斯堡'), ('569', '438', '2822', '海于格松'), ('570', '540', '1285', '斯托姆加斯特'), ('571', '440', '509', '利勒斯特罗姆'), ('572', '441', '505', '莫尔德'), ('573', '351', '507', '罗森博格'), ('574', '439', '472', '博多格林特'), ('575', '534', '512', '松达尔'), ('576', '1131', '1280', '奥勒松'), ('577', '429', '475', '斯塔贝克'), ('578', '437', '1284', '斯达'), ('579', '443', '514', '特罗姆瑟'), ('580', '445', '479', '奥德格伦兰'), ('581', '447', '495', '维京'), ('582', '442', '485', '瓦勒伦加'), ('583', '3076', '4174', '基斯迪辛特'), ('584', '538', '1282', '桑德菲杰'), ('585', '287', '235', '海伦芬'), ('586', '256', '252', '费耶诺德'), ('587', '868', '414', '泽沃勒'), ('588', '255', '246', '维迪斯'), ('589', '257', '243', '格拉夫夏普'), ('590', '241', '288', '坎布尔'), ('591', '127', '233', '罗达JC'), ('592', '870', '278', '赫拉克莱斯'), ('593', '764', '256', '海牙'), ('594', '129', '254', '埃因霍温'), ('595', '128', '237', '乌德勒支'), ('596', '243', '234', '艾克马亚'), ('597', '130', '253', '阿贾克斯'), ('598', '116', '239', '尼美根'), ('599', '867', '270', 'SBV精英'), ('600', '758', '236', '格罗宁根'), ('601', '113', '250', '特温特'), ('602', '115', '225', '威廉二世'), ('603', '783', '232', '布雷达'), ('604', '874', '280', '前进之鹰'), ('605', '763', '287', '多德勒支'), ('606', '303', '273', '鹿特丹斯巴达'), ('607', '765', '277', '芬洛'), ('608', '114', '241', '瓦尔韦克'), ('653', '69', '102', '马拉加'), ('654', '59', '93', '拉科鲁尼亚'), ('655', '63', '109', '马德里竞技'), ('656', '833', '126', '艾尔切'), ('657', '64', '994', '巴列卡诺'), ('658', '819', '98', '赫塔菲'), ('659', '68', '106', '皇家社会'), ('660', '839', '107', '比利亚雷亚尔'), ('661', '824', '131', '埃瓦尔'), ('662', '70', '100', '西班牙人'), ('663', '820', '146', '科尔多瓦'), ('664', '53', '92', '毕尔巴鄂竞技'), ('665', '52', '82', '皇家马德里'), ('666', '55', '91', '巴伦西亚'), ('667', '832', '103', '莱万特'), ('668', '62', '114', '塞尔塔'), ('669', '67', '86', '塞维利亚'), ('670', '65', '84', '巴塞罗那'), ('671', '1799', '141', '阿尔梅里亚'), ('672', '925', '121', '格拉那达'), ('673', '838', '991', '拉斯帕尔马斯'), ('674', '54', '96', '皇家贝蒂斯'), ('675', '830', '113', '希洪竞技'), ('676', '131', '94', '奥萨苏纳'), ('677', '60', '137', '阿拉维斯'), ('678', '825', '992', '雷加利斯'), ('679', '2783', '982', '赫罗纳'), ('680', '58', '123', '瓦拉多利德'), ('681', '2188', '486', '埃斯托里尔'), ('682', '2187', '1555', '费伦斯'), ('683', '122', '457', '博阿维斯塔'), ('684', '5948', '9046', '艾路卡'), ('685', '298', '440', '塞图巴尔'), ('686', '292', '926', '比兰尼塞斯'), ('687', '8071', '19599', '唐迪拉'), ('688', '299', '463', '本菲卡'), ('689', '107', '927', '吉马雷斯'), ('690', '288', '459', '布拉加'), ('691', '936', '951', '葡萄牙国民'), ('692', '2008', '999', '查维斯'), ('693', '108', '924', '摩里伦斯'), ('694', '786', '1006', '费雷拉'), ('695', '296', '466', '里斯本竞技'), ('696', '264', '452', '马里迪莫'), ('697', '121', '476', '里奥阿维'), ('698', '297', '468', '波尔图'), ('699', '785', '1000', '艾维斯'), ('700', '1463', '1554', '朴迪莫伦斯'), ('701', '613', '259', '尼斯'), ('702', '302', '263', '南特'), ('703', '310', '245', '巴斯蒂亚'), ('704', '313', '251', '雷恩'), ('705', '315', '208', '波尔多'), ('706', '950', '4957', '兰斯'), ('707', '607', '266', '里尔'), ('708', '304', '271', '巴黎圣日尔曼'), ('709', '228', '205', '里昂'), ('710', '146', '333', '洛里昂'), ('711', '249', '211', '马赛'), ('712', '347', '257', '卡昂'), ('713', '311', '351', '蒙彼利埃'), ('714', '614', '304', '安格斯'), ('715', '426', '362', '甘冈'), ('716', '248', '197', '摩纳哥'), ('717', '246', '216', '图卢兹'), ('718', '145', '255', '圣埃蒂安'), ('719', '940', '2141', 'GFC阿雅克肖'), ('720', '229', '366', '特鲁瓦'), ('721', '314', '214', '梅斯'), ('722', '2327', '2105', '伊维恩'), ('723', '309', '202', '朗斯'), ('724', '125', '301', '南锡'), ('725', '1364', '320', '第戎'), ('726', '148', '260', '斯特拉斯堡'), ('727', '151', '382', '亚眠'), ('728', '1426', '2104', '瓦朗谢纳'), ('729', '126', '267', '索肖'), ('730', '610', '194', '阿雅克肖'), ('754', '1002', '2460', '安郅马哈奇卡拉'), ('755', '997', '300', '苏维埃之翼'), ('756', '847', '407', '莫斯科中央陆军'), ('757', '2057', '441', '喀山鲁宾'), ('758', '1537', '298', '阿姆卡尔'), ('759', '7164', '10112', '克拉斯诺达尔'), ('760', '840', '411', '莫斯科斯巴达'), ('761', '9004', '13988', '乌法'), ('762', '562', '429', '罗斯托夫'), ('763', '2407', '605', '格罗兹尼特里克'), ('764', '2290', '435', '库班'), ('765', '4174', '2450', '乌拉尔'), ('766', '560', '395', '圣彼得堡泽尼特'), ('767', '846', '416', '莫斯科迪纳摩'), ('768', '4173', '4371', '萨兰斯克莫尔多瓦'), ('769', '668', '420', '莫斯科火车头'), ('770', '849', '296', '莫斯科鱼雷'), ('771', '8753', '19764', '图拉兵工厂'), ('772', '5460', '5755', '奥伦堡加索维克'), ('773', '2288', '2036', '托木斯克'), ('774', '4167', '2481', 'SKA哈巴罗夫斯克'), ('775', '13503', '21640', '鲁安图斯诺'), ('777', '13', '19', '阿森纳'), ('778', '29', '62', '西汉姆联'), ('779', '183', '348', '伯恩茅斯'), ('780', '24', '20', '阿斯顿维拉'), ('781', '15', '24', '切尔西'), ('782', '259', '1194', '斯旺西'), ('783', '31', '31', '埃弗顿'), ('784', '27', '53', '沃特福德'), ('785', '14', '59', '莱切斯特城'), ('786', '16', '65', '桑德兰'), ('787', '32', '27', '曼彻斯特联'), ('788', '30', '33', '托特纳姆热刺'), ('789', '23', '28', '纽卡斯尔联'), ('790', '18', '30', '南安普敦'), ('791', '168', '34', '诺维奇'), ('792', '162', '35', '水晶宫'), ('793', '96', '58', '斯托克城'), ('794', '26', '25', '利物浦'), ('795', '175', '18', '西布罗姆维奇'), ('796', '167', '26', '曼彻斯特城'), ('797', '184', '46', '伯恩利'), ('798', '171', '50', '女王公园巡游者'), ('799', '214', '384', '赫尔城'), ('800', '21', '17', '米德尔斯堡'), ('801', '211', '60', '布莱顿'), ('802', '166', '344', '哈德斯菲尔德'), ('803', '188', '64', '卡迪夫城'), ('804', '170', '29', '富勒姆'), ('805', '9151', '12284', '萨尔米安杜'), ('806', '895', '276', '萨斯菲尔德'), ('807', '9310', '10655', '帕特罗纳图'), ('808', '906', '265', '圣洛伦索'), ('809', '1303', '728', '班菲尔德'), ('810', '896', '283', '拉普拉塔体操'), ('811', '891', '285', '科隆竞技'), ('812', '1746', '297', '萨兰迪兵工厂'), ('813', '905', '262', '河床'), ('814', '2133', '294', '基尔梅斯'), ('815', '897', '295', '阿根廷独立'), ('816', '894', '4465', '贝尔格拉诺'), ('817', '903', '293', '罗萨里奥中央'), ('818', '3802', '4464', '戈多伊克鲁斯'), ('819', '6145', '5106', '阿尔多斯维'), ('820', '1747', '732', '奥林匹奥'), ('821', '907', '708', '阿根廷青年人'), ('822', '4735', '5107', '泰格雷'), ('823', '898', '5283', '飓风队'), ('824', '2134', '2609', '拉斐拉竞技'), ('825', '901', '269', '拉普拉塔大学生'), ('826', '899', '291', '拉努斯'), ('827', '6147', '5114', '防卫者'), ('828', '892', '5096', '圣塔菲联'), ('829', '9605', '13243', 'CA坦波利'), ('830', '889', '261', '博卡青年'), ('831', '6148', '8489', '图库曼竞技'), ('832', '890', '299', '竞技俱乐部'), ('833', '4736', '6146', '圣胡安圣马丁'), ('834', '902', '272', '纽维尔老男孩'), ('835', '893', '5113', '塔勒瑞斯'), ('836', '900', '5115', '查卡里塔青年'), ('837', '276', '1419', '那不勒斯'), ('838', '87', '166', '尤文图斯'), ('839', '84', '174', '罗马'), ('840', '77', '182', '拉齐奥'), ('841', '271', '179', '桑普多利亚'), ('842', '272', '523', '恩波利'), ('843', '2889', '2960', '森索罗'), ('844', '86', '187', '乌迪内斯'), ('845', '72', '558', '都灵'), ('846', '80', '150', 'AC米兰'), ('847', '265', '515', '切塞纳'), ('848', '267', '195', '切沃'), ('849', '73', '176', '佛罗伦萨'), ('850', '75', '152', '国际米兰'), ('851', '76', '559', '维罗纳'), ('852', '278', '552', '热那亚'), ('853', '300', '154', '亚特兰大'), ('854', '1285', '168', '巴勒莫'), ('855', '78', '183', '卡利亚里'), ('856', '82', '189', '帕尔马'), ('857', '2732', '1359', '弗洛西诺尼'), ('858', '71', '185', '博洛尼亚'), ('859', '9363', '15060', '卡皮'), ('860', '779', '554', '克罗托内'), ('861', '277', '560', '佩斯卡拉'), ('862', '1502', '1408', '史帕尔'), ('863', '1503', '1420', '贝内文托'), ('864', '1286', '192', '利沃诺'), ('865', '1292', '508', '卡塔尼亚'), ('866', '2538', '16668', '广州富力'), ('867', '15181', '16961', '河北华夏幸福'), ('868', '4152', '541', '河南建业'), ('869', '9081', '7642', '上海上港'), ('870', '4089', '542', '杭州绿城'), ('871', '3618', '528', '长春亚泰'), ('872', '2530', '39', '上海绿地申花'), ('873', '9084', '1998', '延边富德'), ('874', '7125', '543', '江苏苏宁'), ('875', '2531', '40', '山东鲁能泰山'), ('876', '11145', '16967', '石家庄永昌'), ('877', '2535', '41', '辽宁沈阳开新'), ('878', '2533', '83', '重庆力帆'), ('879', '4673', '535', '广州恒大淘宝'), ('880', '2532', '89', '天津泰达亿利'), ('881', '2540', '43', '北京中赫国安'), ('882', '10109', '8686', '贵州恒丰智诚'), ('883', '10108', '8685', '天津权健'), ('884', '133', '529', '贝西克塔斯'), ('885', '156', '526', '根克勒比利吉'), ('886', '3475', '4469', '卡斯帕萨'), ('887', '2006', '742', '干亚斯堡'), ('888', '2201', '1595', '伊斯坦堡普野社希尔'), ('889', '2864', '4468', '埃斯基谢希尔体育'), ('890', '226', '530', '特拉布宗体育'), ('891', '294', '516', '加拉塔萨雷'), ('892', '221', '1589', '布尔萨体育'), ('893', '220', '521', '加济安泰普体育'), ('894', '2812', '1677', '卡拉比克体育'), ('895', '750', '1561', '里泽斯堡'), ('896', '2192', '1569', '梅尔辛'), ('897', '6279', '6912', '巴里科斯士邦'), ('898', '223', '537', '费内巴切'), ('899', '5729', '6915', '阿卡沙'), ('900', '2003', '1566', '锡瓦斯体育'), ('902', '227', '1598', '安塔利亚体育'), ('903', '2005', '532', '奥斯曼里士邦'), ('904', '2200', '519', '开塞利体育'), ('905', '153', '1593', '艾丹亚斯普'), ('906', '3473', '4547', '阿兰亚斯堡'), ('907', '5732', '533', '马拉蒂亚体育'), ('908', '254', '1666', '哥茲塔比');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
